User Security (SY10000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY10000

Display Name: User Security
Physical Name: SY10000
Technical Name: sySecurityView

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['User Security'].USERID AS 'User Security-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SY10000 AS ['User Security'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['User Security'].USERID = ['Users Master'].USERID
2	CMPANYID	Company ID	Integer	INT5	4
	Key to the Company Master (SY01500). Click to show/hide SELECT ['User Security'].CMPANYID AS 'User Security-Company ID' ,['Company Master'].CMPANYID AS 'Company Master-Company ID' FROM SY10000 AS ['User Security'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['User Security'].CMPANYID = ['Company Master'].CMPANYID
3	DICTID	DictID	Integer	ID_INT	4
4	SECURITYID	Security ID	Long Integer	Long_10U	10
5	SECRESTYPE	Security Resource Type	Integer	Restype	2
6	ALTDICID	AltDictID	Integer	ID_INT	4
7	Modified	Modified	Boolean	YN	0